package com.sugon.dao;

import com.sugon.entity.ToolsCheckJudgeStandardEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 工装精度检测判定标准Dao
 *
 * @author sugon
 * @date 2021-09-22 12:01:54
 */
public interface ToolsCheckJudgeStandardDao extends BaseDao<ToolsCheckJudgeStandardEntity> {

    /**
     * 根据工装ID和判定标准查询是否已关联过
     *
     * @param toolsFileId
     * @param judgeStandard
     * @return
     */
    @Select("SELECT id FROM tools_check_judge_standard WHERE tools_file_id = #{toolsFileId} AND judge_standard = #{judgeStandard}")
    List<String> query(@Param("toolsFileId") String toolsFileId, @Param("judgeStandard") String judgeStandard);

}
